﻿IF object_id(N'dbo.UDS_CM_ClientInfo', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_CM_ClientInfo] (
        [ID]                int           NOT NULL identity(1, 1),
        [ChiefLinkmanID]    int           NULL,
        [Birthday]          datetime      NULL,
        [UpdateTime]        datetime      NULL,
        [Name]              nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ShortName]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ContactTimes]      int           NULL CONSTRAINT [DF_UDS_CM_ClientInfo_ContactTimes] default(((0))),
        [SellPhase]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [BargainPrognosis]  nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Fee]               int           NULL,
        [AddManID]          int           NULL,
        [Linkman_Telephone] nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [CurStatus]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Type]              nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Affiliatedarea]    nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [URL]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ZIP]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Address]           nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [CompanyProperty]   nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [Calling]           nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL,
        [CompanySize]       nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Money]             nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Operation]         nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [Introduce]         nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [ITGrade]           nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [PCNumber]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Net]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ITStaffs]          int           NULL,
        [ITDepartment]      nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Principal]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [System]            nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [Customer]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ClientInitiative]  nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [FirstContactTime]  datetime      NULL,
        [NextContactTime]   datetime      NULL,
        [ContactTime]       datetime      NULL,

        CONSTRAINT [PK_UDS_CM_ClientInfo] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
